/**
 * @description: 项目管理
 * @version: 0.0.1
 * @author: ljr
 * @Date: 2023-09-12 11:33:58
 */
import {
  Table,
  Model,
  Column,
  CreatedAt,
  UpdatedAt,
  DataType,
} from 'sequelize-typescript';

@Table({ tableName: 'project_records' })
export class ProjectRecord extends Model {
  @Column({
    primaryKey: true,       //主键
    autoIncrement: true,    //自增
    comment: "自增id"       //注释:只在代码中有效
  })
  id: number;
  
  @Column(DataType.TEXT)
  project_name: string; //项目名称

  @Column(DataType.TEXT)
  project_content: string; //项目内容

  @Column(DataType.TEXT)
  project_progress: string; //项目进度

  @Column(DataType.TEXT)
  project_type: string; //项目类型

  @Column(DataType.TEXT)
  user_id: string;     //负责人id

  @Column(DataType.TEXT)
  user_name: string;//负责人名称

  @Column(DataType.TEXT)
  create_userid: number;//创建人id

  @Column(DataType.TEXT)
  create_username: string; //创建人名称

  @CreatedAt
  created_at: Date; 

  @UpdatedAt
  updated_at: Date;

  @Column(DataType.TEXT)
  is_del: number;

  @Column(DataType.TEXT)
  brand_name: string; //品牌名称

  @Column(DataType.INTEGER)
  is_import: number;  //是否是导入的项目信息  0否  1是

  @Column(DataType.TEXT)
  chuanyun_object_id: string;  //氚云导入项目的ObjectId
}